package com.clkj.zhonghui.dao.stored;

import com.clkj.zhonghui.pojo.stored.StoredGrade;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

/**
 * @author yawang
 * @create 2024/07/16 11:38:04
 **/
@Repository
public interface StoredGradeMapper extends Mapper<StoredGrade> {
    @Select("select  top 1 * from t_zh_StoredGrade where #{totals} >=stored_money   order by grand desc")
    StoredGrade listNum(@Param("totals")Double totals);
}
